Opening an oracle database crashes the service [SOLVED]

Posted by tundal45 on Server Fault See other posts from Server Fault or by tundal45
Published on 2010-03-18T13:31:51Z Indexed on 2010/03/19 14:11 UTC
Read the original article Hit count: 252

Filed under:

oracle10g

|

database-adminstration

|

crash

|

Services

I am experiencing a weird issue with Oracle where the service started fine after a crash. The database mount went fine as well. However, when I issue alter database open; command, the database does not open, gives a generic cannot connect to the database error & crashes the service.

Oracle support has not seen this issue before so it's pretty scary. The fact that there are no logs that give any leads as to what could be causing this is also scary.

I was wondering if good folks over at Server Fault had seen something like this or have some insights on things that I could try.

It's Oracle 10g running on Windows Server 2003.

Thanks,

Ashish

© Server Fault or respective owner

Related posts about oracle10g

How to set _optimizer_search_limit and _optimizer_max_permutations in Oracle10g.

as seen on Server Fault - Search for 'Server Fault'
I am working on a product that must support both MSSQL and Oracle (10g and 11g). I have some very complex queries that seem to run without issue on MSSQL 2005/2008, but very, very slow with Oracle. The CPU on the oracle server skyrockets for long periods of time, and it seems like the optimizer… >>> More
Any suggestions on how to extract 6 million records from an oracle10g ?

as seen on Stack Overflow - Search for 'Stack Overflow'
I just want to give you a little background Need to write a PL-SQL which will extract 6 million record joining different tables and create a file of that. Need more suggestions, specifically on how to fetch these many records. As fetching these million of records on a single go can be a highly resource… >>> More
How to write a optimized code to fetch 6 million records from Oracle10G database and write them on a

as seen on Stack Overflow - Search for 'Stack Overflow'
What to use in oracle 10G to extract 6 million records and create a flat file of it ? >>> More
how to know the names of other users in oracle10g?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi guys,i want to know how can we know the other users of oracle 10g on the same system. Is there any querry for that? thank you!!! >>> More
Where is the C precompiler for Oracle10g located?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am looking for a newer version of the Pro*C/C++ to upgrade my procui.exe 9.0.1.1.1. I downloaded the 10g client disk and when install I have the following options: instant client administrator runtime custom I dont seem to able to find the actual program other than just getting some… >>> More

Related posts about database-adminstration

sybase bcp import fails

as seen on Server Fault - Search for 'Server Fault'
We're trying to export some tables from our production database to our test database using bcp. The bcp export seems to work fine, but the import always fails with a data type error (see below). We tested on our test database exporting the table content to a file, then importing it in again immediately… >>> More
DB2 upgrade database Fails due to descriptor corruption

as seen on Server Fault - Search for 'Server Fault'
Hi Everyone, I've recently upgraded my DB2 9.5 to DB2 9.7, and I am unable to update my database to v9.7. The error I have been receiving is this: "SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "Packed descriptor corruption… >>> More
Very large database, very small portion most being retrieved in real time

as seen on Server Fault - Search for 'Server Fault'
Hi folks, I have an interesting database problem. I have a DB that is 150GB in size. My memory buffer is 8GB. Most of my data is rarely being retrieved, or mainly being retrieved by backend processes. I would very much prefer to keep them around because some features require them. Some of it (namely… >>> More
What is "The" book for database design?

as seen on Server Fault - Search for 'Server Fault'
In programming, there is often a canonical book for a particular topic, like the dragon book for compilers, K&R for C, etc. Is their a book regarding modern database design that simply must be read by anyone that would hope to eventually design databases? I'm not looking for a bunch of recommendations… >>> More
How much effort is SQL Server 2008 Administration?

as seen on Server Fault - Search for 'Server Fault'
Hi, I am looking for a suitable hosting environment for an ASP.NET MVC application. One of the options I have is renting a Hyper-V server and installing my license of SQL Server 2008 on it. I'm a bit wary of shared hosting since the one I have tried so far did not seem to have very consistent performance… >>> More